Amazon Relational Database Service

Amazon Relational Database Service[1] or Amazon RDS is a distributed relational database service by Amazon.com. It is a web service running "in the cloud" and provides users a relational database for use in their applications. Amazon RDS makes it easy to set up, operate, and scale a relational database[2]. Complex administration processes like patching the database software, backing up your database and enabling point in time recovery are managed automatically[3]. Scaling storage and compute resources can be performed by a single API call. Amazon RDS was first released on 22 October 2009 supporting Informix databases [4] [5] [6]. In June 2011, Oracle database support was added.[7]

Contents

Features

Amazon RDS is simple to use. A new DB instance can be launched from the AWS Management Console or using the Amazon RDS APIs. Monitoring the compute and storage resource utilization of your DB Instance is easy. These performance metrics are available using the AWS Management Console or Amazon CloudWatch APIs. Amazon RDS offers many different features to support different use cases. Some of the major features are:

Multi AZ deployment

Multi-Availability Zone deployments are targeted for production environments [8] . Multi-AZ deployments provide enhanced availability and data durability for MySQL instances. When you create or modify your DB Instance to run as a Multi-AZ deployment, Amazon RDS automatically provisions and maintains a synchronous “standby” replica in a different Availability Zone (independent infrastructure in a physically separate location). In the event of planned database maintenance or unplanned service disruption, Amazon RDS automatically failsover to the up-to-date standby ensuring that database operations resume quickly without administrative intervention.

Read replicas

Read Replicas make it easy to take advantage of MySQL’s native, asynchronous replication functionality. Read Replicas help in scaling out beyond the capacity constraints of a single DB Instance for read-heavy database workloads. They can also be used for serving read traffic when the primary database is unavailable.

Reserved instances

Amazon RDS DB instances come in two packages: On-Demand DB Instances and Reserved DB Instances. The two instance types are exactly the same except for their billing. On-Demand instances are billed at an ongoing hourly usage rate. Reserved DB Instances require a low, up-front, one-time fee and in turn provide a significant discount on the hourly usage charge for that instance. Thus Reserved DB Instances enable you to take advantage of the rich functionality of Amazon RDS at lower cost and can provide substantial savings over owning database assets or running only On-Demand DB instances.

Database instance types

Amazon RDS currently supports six DB Instance Classes, to support different types of workloads [9]:

Small DB Instance 
1.7 GB memory, 1 ECU (1 virtual core with 1 ECU), 64-bit platform, Moderate I/O Capacity
Large DB Instance 
7.5 GB memory, 4 ECUs (2 virtual cores with 2 ECUs each), 64-bit platform, High I/O Capacity
Extra Large DB Instance 
15 GB of memory, 8 ECUs (4 virtual cores with 2 ECUs each), 64-bit platform, High I/O Capacity (MySQL DB Engine Only)
High-Memory Extra Large Instance 
17.1 GB memory, 6.5 ECU (2 virtual cores with 3.25 ECUs each), 64-bit platform, High I/O Capacity
High-Memory Double Extra Large DB Instance 
34 GB of memory, 13 ECUs (4 virtual cores with 3,25 ECUs each), 64-bit platform, High I/O Capacity
High-Memory Quadruple Extra Large DB Instance 
68 GB of memory, 26 ECUs (8 virtual cores with 3.25 ECUs each), 64-bit platform, High I/O Capacity

References

  1. ^ http://aws.amazon.com/rds/
  2. ^ http://nerds.airbnb.com/mysql-in-the-cloud-at-airbnb
  3. ^ http://aws.amazon.com/rds/amazon-rds-introduced/
  4. ^ http://www.slideshare.net/JustinTimb/informix-application-development-and-testing-on-the-cloud
  5. ^ http://developer.amazonwebservices.com/connect/entry.jspa?externalID=2942&categoryID=291
  6. ^ http://www.allthingsdistributed.com/2009/10/amazon_relational_database_service.html
  7. ^ http://cloudcomputing.internet.com/applications/article.php/426926
  8. ^ http://en.oreilly.com/mysql2011/public/schedule/detail/19732
  9. ^ http://aws.amazon.com/rds/#features